package com.k2091.washcar.mapper;

import com.k2091.washcar.entity.Examine;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.k2091.washcar.entity.FormInline;
import com.k2091.washcar.entity.UsersCar;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author author
 * @since 2021-06-02
 */
public interface ExamineMapper extends BaseMapper<Examine> {
    @Select("select * from examine where id=#{id}")
    List<Examine> selectExamineById(@Param("id") Long id);

    @Insert("insert into examine values(null,#{id},null,now(),0,#{name},#{phonenum},null,null,#{sex},#{age},#{email}) ")

    int insert(@Param("name")String name,@Param("id")Long id,@Param("phonenum")String phonenum,@Param("sex")int sex,
               @Param("age")int age,@Param("email")String email);

    List<Examine> selectExamine(FormInline formInline);
}
